﻿-- =============================================
-- Execute after table creation
-- =============================================


use dominium
go

---SalesRoles Inserts
--set identity_insert SalesRole on;
insert into dbo.SalesRole (RoleName) values ('Executive Sponsor');
insert into dbo.SalesRole (RoleName) values ('Producer');
insert into dbo.SalesRole ( RoleName) values ('Service Account Exec');
insert into dbo.SalesRole (RoleName) values ('Analytical Account Exec');
insert into dbo.SalesRole (RoleName) values ('Consultant');
--set identity_insert SalesRole off;


--InsuranceType
insert into dbo.InsuranceType ([InsuranceTypeName]  )values ('Fully Insured');
insert into dbo.InsuranceType ([InsuranceTypeName]  )values ('Self Insured');

--RevenueType
insert into dbo.RevenueType ([RevenueTypeName])values ('Commission');
insert into dbo.RevenueType ([RevenueTypeName])values ('Bonus');
insert into dbo.RevenueType ([RevenueTypeName])values ('Consultation Fee');
insert into dbo.RevenueType ([RevenueTypeName])values ('Other');


--ClientTypes
insert into dbo.ClientTypes ([ClientTypeName])values ('Individual Brokerage');
insert into dbo.ClientTypes ([ClientTypeName])values ('Individual Consulting');
insert into dbo.ClientTypes ([ClientTypeName])values ('Individual Pharmacy');
insert into dbo.ClientTypes ([ClientTypeName])values ('Individual Voluntary Only');
insert into dbo.ClientTypes ([ClientTypeName])values ('Corporate Brokerage');
insert into dbo.ClientTypes ([ClientTypeName])values ('Corporate Consulting');
insert into dbo.ClientTypes ([ClientTypeName])values ('Corporate Pharmacy');
insert into dbo.ClientTypes ([ClientTypeName])values ('Corporate Voluntary Only');

---LineOfBusiness 
--set identity_insert dbo.LineOfBusiness on;
insert into dbo.LineOfBusiness (LOBName) values ('Medical');
insert into dbo.LineOfBusiness (LOBName) values ('Dental');
insert into dbo.LineOfBusiness (LOBName) values ('Vision');
insert into dbo.LineOfBusiness (LOBName) values ('Pharmacy');
insert into dbo.LineOfBusiness (LOBName) values ('Mini Med');
insert into dbo.LineOfBusiness (LOBName) values ('401');
insert into dbo.LineOfBusiness (LOBName) values ('Basic Life');
insert into dbo.LineOfBusiness (LOBName) values ('Executive Life');
insert into dbo.LineOfBusiness (LOBName) values ('FSA');
insert into dbo.LineOfBusiness (LOBName) values ( 'LTD');
insert into dbo.LineOfBusiness (LOBName) values ('STD');
insert into dbo.LineOfBusiness (LOBName) values ('Unum Accident and Critical Illness');
insert into dbo.LineOfBusiness (LOBName) values ('Voluntary Accident');
insert into dbo.LineOfBusiness (LOBName) values ('Voluntary Critical Illness');
insert into dbo.LineOfBusiness (LOBName) values ('Voluntary Dental');
insert into dbo.LineOfBusiness (LOBName) values ('Executive Life');
insert into dbo.LineOfBusiness (LOBName) values ('Voluntary Life');
insert into dbo.LineOfBusiness (LOBName) values ( 'Voluntary LTD');
insert into dbo.LineOfBusiness (LOBName) values ( 'Voluntary STD');
insert into dbo.LineOfBusiness (LOBName) values ( 'Voluntary Vision');
--set identity_insert dbo.LineOfBusiness off;

---- Address
insert into [Address] (AddressHash,Line1,Line2,City,[State],Zip) values ('fiveconcourseparkwaysuite2305atlantaga30328'	,'Five Concourse Parkway',	'Suite 2325',	'Atlanta',	'GA',	'30328')
insert into [Address] (AddressHash,Line1,City,State,Zip) values ('100Pier1PlaceFortWorthTX76102','100 Pier 1 Place','Fort Worth','TX','76102');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1000chastainroadmailbox3504kennesawga30144','1000 Chastain Road','Mail Box #3504','Kennesaw','GA','30144');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1000marblemillcirclemariettaga30060','1000 Marble Mill Circle','','Marietta','GA','30060');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1000ternesdrivemonroemi48162','1000 Ternes Drive','','Monroe','MI','48162');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('101mariettastreetsuite1900atlantaga30303','101 Marietta Street','Suite 1900','Atlanta','GA','30303');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('107parkwashingtonctfallschurchva22046','107 Park Washington Ct','','Falls Church','VA','22046');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1100lakehearndrsuite450atlantaga30342','1100 Lake Hearn Dr.','Suite 450','Atlanta','GA','30342');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1117perimetercenterwestsuiten306atlantaga30328','1117 Perimeter Center West','Suite N-306','Atlanta','GA','30328');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1117perimetercenterwestsuiten306atlantaga30338','1117 Perimeter Center West','Suite N-306','Atlanta','GA','30338');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1125satelliteblvdsuite100suwaneega30024','1125 Satellite Blvd','Suite 100','Suwanee','GA','30024');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('11301corporateblvdsuite101orlandofl32817','11301 Corporate Blvd','Suite 101','Orlando','FL','32817');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1180peachtreestreetatlantaga30309','1180 Peachtree Street','','Atlanta','GA','30309');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1180westpeachtreestreetnwsuite400atlantaga30309','1180 West Peachtree Street NW','Suite 400','Atlanta','GA','30309');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1192fosterstreetnwatlantaga303184329','1192 Foster Street, NW','','Atlanta','GA','30318-4329');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1201peachtreeroadsuite300atlantaga30361','1201 Peachtree Road','Suite 300','Atlanta','GA','30361');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('125southshorecourtroswellga30076','125 South Shore Court','','Roswell','GA','30076');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1301newsavannahroadaugustaga30901','1301 New Savannah Road','','Augusta','GA','30901');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('130technologyparkwaynorcrossga30092','130 Technology Parkway','','Norcross','GA','30092');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1349wpeachtreestnwsuite1700atlantaga30309','1349 W. Peachtree St., NW','Suite 1700','Atlanta','GA','30309');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('150mountvernonstbostonma02125','150 Mount Vernon St','','Boston','MA','02125');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('150mountvernonstbostonma2125','150 Mount Vernon St','','Boston','MA','2125');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('151walkerroadstatesvillenc28625','151 Walker Road','','Statesville','NC','28625');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('155robinsondrivefayettevillega30214','155 Robinson Drive','','Fayetteville','GA','30214');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1575northsidedrivebuilding300suite350atlantaga3031','1575 Northside Drive, Building 300','Suite 350','Atlanta','GA','30318');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1695edgefieldrdnorthaugustasc29860','1695 Edgefield Rd.','','North Augusta','SC','29860');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1700piedmontaveneatlantaga30324','1700 Piedmont Ave NE','','Atlanta','GA','30324');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1762loverslaneaugustaga30901','1762 Lovers Lane','','Augusta','GA','30901');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1819peachtreeroadsuite425atlantaga30309','1819 Peachtree Road','Suite 425','Atlanta','GA','30309');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('191peachtreesuite2400atlantaga303031740','191 Peachtree','Suite 2400','Atlanta','GA','30303-1740');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1glenlakeparkwaysuite1225atlantaga30082','1 Glenlake Parkway','Suite 1225','Atlanta','GA','30082');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('1royaloakavenueroswellga30076','1 Royal Oak Avenue','','Roswell','GA','30076');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('200westparkdrivesuite100peachtreecityga30269','200 Westpark Drive','Suite 100','Peachtree City','GA','30269');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('2100riveredgeparkwaysuite200atlantaga30328','2100 RiverEdge Parkway','Suite 200','Atlanta','GA','30328');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('2111wilsonblvdsuite210arlingtonva22201','2111 Wilson Blvd','Suite 210','Arlington','VA','22201');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('2111wilsonblvdsuite350arlingtonva22201','2111 Wilson Blvd','Suite 350','Arlington','VA','22201');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('211wilsonblvdsuite210arlingtonva22201','211 Wilson Blvd','Suite 210','Arlington','VA','22201');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('229peachtreestreetsuite800atlantaga30303','229 Peachtree Street','Suite 800','Atlanta','GA','30303');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('2300westparkplacestonemountainga30087','2300 West Park Place','','Stone Mountain','GA','30087');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('230johnwesleydobbsavenueatlantaga30303','230 John Wesley Dobbs Avenue','','Atlanta','GA','30303');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('231whancockstreethallhousemilledgevillega310613375','231 W. Hancock Street','Hall House','Milledgeville','GA','31061-3375');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('2416musicvalleydrivesuite102nashvilletn37214','2416 Music Valley Drive','Suite 102','Nashville','TN','37214');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('2600schooldriveatlantaga30360','2600 School Drive','','Atlanta','GA','30360');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('2655northwindsparkwayalpharettaga30004','2655 Northwinds Parkway','','Alpharetta','GA','30004');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('2655northwindsparkwayalpharettaga30009','2655 North Winds Parkway','','Alpharetta','GA','30009');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('270peachtreestreetsuite1300atlantaga30303','270 Peachtree Street','Suite 1300','Atlanta','GA','30303');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('280technologyparkwaynorcrossga30092','280 Technology Parkway','','Norcross','GA','30092');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('2849pacesferryrdsuite350atlantaga30339','2849 Paces Ferry Rd.','Suite 350','Atlanta','GA','30339');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('2859pacesferryroadsuite2000atlantaga30339','2859 Paces Ferry Road','Suite 2000','Atlanta','GA','30339');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('303peachtreestreetneatlantaga30308','303 Peachtree Street NE','','Atlanta','GA','30308');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3108piedmontroadsuite160atlantaga30305','3108 Piedmont Road','Suite 160','Atlanta','GA','30305');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3110aashforddunwoodyroadatlantaga30319','3110-A Ashford Dunwoody Road','','Atlanta','GA','30319');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3155medlockbridgerdnorcrossga30071','3155 Medlock Bridge Rd.','','Norcross','GA','30071');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3205northwoodsparkwaynorcrossga30071','3205 Northwoods Parkway','','Norcross','GA','30071');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3211shannonroadsuite410durhamnc27707','3211 Shannon Road','Suite 410','Durham','NC','27707');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3344peachtreerdnesuite1800atlantaga30326','3344 Peachtree Rd. NE','Suite 1800','Atlanta','GA','30326');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3445peachtreeroadnesuite500atlantaga30326','3445 Peachtree Road NE','Suite 500','Atlanta','GA','30326');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3445peachtreeroadsuite500atlantaga30326','3445 Peachtree Road','Suite 500','Atlanta','GA','30326');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3500lenoxrdsuite500atlantaga30326','3500 Lenox Rd.','Suite 500','Atlanta','GA','30326');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3565piedmontrdbuilding2suite400atlantaga30305','3565 Piedmont Rd. Building 2','Suite 400','Atlanta','GA','30305');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('359eastpacesferryroadsuite300atlantaga30305','359 East Paces Ferry Road','Suite 300','Atlanta','GA','30305');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3621viningsslopesuite400atlantaga30339','3621 Vinings Slope','Suite 400','Atlanta','GA','30339');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3651marshillrdsuite400watkinsvillega30677','3651 Mars Hill Rd.','Suite 400','Watkinsville','GA','30677');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('3715northsideparkwaynwbuilding200suite440atlantaga','3715 Northside Parkway, NW','Building 200, Suite 440','Atlanta','GA','30327')
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('4000suntrustplaza303peachtreestreetatlantaga30308','4000 Suntrust Plaza','303 Peachtree Street','Atlanta','GA','30308');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('430technologyparkwaynorcrossga30092','430 Technology Parkway','','Norcross','GA','30092');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('4405northsideparkwayatlantaga30327','4405 Northside Parkway','','Atlanta','GA','30327');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('4635northroyalatlantadrivetuckerga30084','4635 North Royal Atlanta Drive','','Tucker','GA','30084');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('4666fariesparkwaydecaturil62526','4666 Faries Parkway','','Decatur','IL','62526');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('4808claybrookedrivesmyrnaga30087','4808 Clay Brooke Drive','','Smyrna','GA','30087');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('4executiveparkeastsuite400atlantaga30329','4 Executive Park East','Suite 400','Atlanta','GA','30329');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('5052addisoncircleaddisontx75001','5052 Addison Circle','','Addison','TX','75001');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('5405spaldingdrivenorcrossga30092','5405 Spalding Drive','','Norcross','GA','30092');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('5457roswellrdsuite208atlantaga30342','5457 Roswell Rd.','Suite 208','Atlanta','GA','30342');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('5501fultonindustrialBlvdatlantaga30336','5501 Fulton Industrial Blvd','','Atlanta','GA','30336');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('5555glenridgeconnectorsuite1100atlantaga30342','5555 Glenridge Connector','Suite 1100','Atlanta','GA','30342');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('5555triangleparkwaysuite310norcrossga30092','5555 Triangle Parkway','Suite 310','Norcross','GA','30092');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('555mcfarland400drivealpharettaga30004','555 McFarland 400 Drive','','Alpharetta','GA','30004');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('55ivanallenblvdsuite810atlantaga30308','55 Ivan Allen Blvd','Suite 810','Atlanta','GA','30308');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('5700sw34thstreetgainesvillefl32608','5700 SW 34th Street','','Gainesville','FL','32608');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('5950fultonindustrialblvdatlantaga30336','5950 Fulton Industrial Blvd','','Atlanta','GA','30336');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('6200thecornersparkwaynorcrossga30092','6200 The Corners Parkway','','Norcross','GA','30092');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('6303avalondrbedfordma01730','6303 Avalon Dr.','','Bedford','MA','01730');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('6303avalondrbedfordma1730','6303 Avalon Dr.','','Bedford','MA','1730');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('7135charlottepikesuite100nashvilletn37209','7135 Charlotte Pike','Suite 100','Nashville','TN','37209');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('732josephelowryblvdnwatlantaga30318','732 Joseph E. Lowry Blvd NW','','Atlanta','GA','30318');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('750mtzionroadjonesboroga30236','750 Mt. Zion Road','','Jonesboro','GA','30236');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('789churchstreetmariettaga30060','789 Church Street','','Marietta','GA','30060');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('8001southcassavenuedarienil60561','8001 South Cass Avenue','','Darien','IL','60561');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('800bullsborodrivenewnanga30265','800 Bullsboro Drive','','Newnan','GA','30265');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('850univeterroadcantonga30115','850 Univeter Road','','Canton','GA','30115');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('863holcombbridgerdroswellga30076','863 Holcomb Bridge Rd.','','Roswell','GA','30076');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('895cantonrdbuilding100mariettaga30060','895 Canton Rd','Building 100','Marietta','GA','30060');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('895cantonroadmariettaga30060','895 Canton Road','','Marietta','GA','30060');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('9635ventanawayalpharettaga30022','9635 Ventana Way','','Alpharetta','GA','30022');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('9737cogdillrdsuite200nknoxvilletn37932','9737 Cogdill Rd.','Suite 200N','Knoxville','TN','37932');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('onepiedmontcentersuite500atlantaga30305','One Piedmont Center','Suite 500','Atlanta','GA','30305');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('oneraviniadrivesuite200atlantaga30346','One Ravinia Drive','Suite 200','Atlanta','GA','30346');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('pobox1530adelga31620','PO Box 1530','','Adel','GA','31620');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('pobox2065valdostaga31604','PO Box 2065','','Valdosta','GA','31604');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('pobox70681620bassroadmaconga312097068','PO Box 7068','1620 Bass Road','Macon','GA','31209-7068');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('themcgillbuilding2835brandywineroadsuite300atlanta','The McGill Building, 2835 Brandywine Road','Suite 300','Atlanta','GA','30341');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('twoconcourseparkwaysuite100atlantaga30328','Two Concourse Parkway','Suite 100','Atlanta','GA','30328');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('twoconcourseparkwaysuite300atlantaga30328','Two Concourse Parkway','Suite 300','Atlanta','GA','30328');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('twomidtownplaza1349wpeachtreestnwsuite1700atlantag','Two Midtown Plaza, 1349 W. Peachtree St., NW','Suite 1700','Atlanta','GA','30309');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('6625TheCornersParkwaySuite500NorcrossGeorgia300922','6625 The Corners Parkway','Suite 500','Norcross','GA','30092');
insert into [Address] (AddressHash,Line1,Line2,City,State,Zip) values ('fiveconcourseparkwaysuite2325atlantaga30328','Five Concourse Parkway','Suite 2325','Atlanta','GA','30328');



---clients
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Ashworth College',(select AddressId from dbo.[Address] where AddressHash = ('6625TheCornersParkwaySuite500NorcrossGeorgia300922')),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Arrowhead Management',(select AddressId from dbo.[Address] where AddressHash = ('750MtZionRoadJonesboroGA30236')),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Atlanta Spirit',(select AddressId from dbo.[Address] where AddressHash = ('101mariettastreetsuite1900atlantaga30303')),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Pier 1 Imports',(select AddressId from dbo.[Address] where AddressHash = ('100Pier1PlaceFortWorthTX76102')),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Backyard Products',(select AddressId from dbo.[Address] where AddressHash = ('1000ternesdrivemonroemi48162')),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Calypso Holdings (Canvas Systems)',(select AddressId from [Address] where AddressHash = '3205northwoodsparkwaynorcrossga30071'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Cedar Document Technologies',(select AddressId from [Address] where AddressHash = 'oneraviniadrivesuite200atlantaga30346'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('City of Adel',(select AddressId from [Address] where AddressHash = 'pobox1530adelga31620'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Coalition America',(select AddressId from [Address] where AddressHash = 'twoconcourseparkwaysuite300atlantaga30328'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Concierge Services of Atlanta, Inc.',(select AddressId from [Address] where AddressHash = '3715northsideparkwaynwbuilding200suite440atlantaga'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Cooper Carry',(select AddressId from [Address] where AddressHash = '191peachtreesuite2400atlantaga303031740'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Corcoran Jennison',(select AddressId from [Address] where AddressHash = '150mountvernonstbostonma2125'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Corus360',(select AddressId from [Address] where AddressHash = '130technologyparkwaynorcrossga30092'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('DataOceans',(select AddressId from [Address] where AddressHash = '280technologyparkwaynorcrossga30092'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Decision First',(select AddressId from [Address] where AddressHash = '2849pacesferryrdsuite350atlantaga30339'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Dedicated Management Group',(select AddressId from [Address] where AddressHash = '3651marshillrdsuite400watkinsvillega30677'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Diaz Foods',(select AddressId from [Address] where AddressHash = '5501fultonindustrialblvdatlantaga30336'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Digitel Corporation',(select AddressId from [Address] where AddressHash = '2600schooldriveatlantaga30360'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Elarbee Thompson',(select AddressId from [Address] where AddressHash = '229peachtreestreetsuite800atlantaga30303'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('First Multiple Listing Service',(select AddressId from [Address] where AddressHash = '5457roswellrdsuite208atlantaga30342'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Fischbein, LLC',(select AddressId from [Address] where AddressHash = '151walkerroadstatesvillenc28625'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Florida Farm Bureau',(select AddressId from [Address] where AddressHash = '5700sw34thstreetgainesvillefl32608'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Foundation Contractors, Inc.',(select AddressId from [Address] where AddressHash = '1000marblemillcirclemariettaga30060'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('FPL Foods',(select AddressId from [Address] where AddressHash = '1301newsavannahroadaugustaga30901'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Georgia College & State University',(select AddressId from [Address] where AddressHash = '231whancockstreethallhousemilledgevillega310613375'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Georgia Farm Bureau',(select AddressId from [Address] where AddressHash = 'pobox70681620bassroadmaconga312097068'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Georgia Hand, Shoulder & Elbow',(select AddressId from [Address] where AddressHash = '1819peachtreeroadsuite425atlantaga30309'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Georgia Pediatric Pulmonology Associates',(select AddressId from [Address] where AddressHash = '1100lakehearndrsuite450atlantaga30342'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('GLJ Partners',(select AddressId from [Address] where AddressHash = '3621viningsslopesuite400atlantaga30339'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Graves Technology',(select AddressId from [Address] where AddressHash = '4808claybrookedrivesmyrnaga30087'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('GrayLine Nashville',(select AddressId from [Address] where AddressHash = '2416musicvalleydrivesuite102nashvilletn37214'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Hawkins & Parnell',(select AddressId from [Address] where AddressHash = '4000suntrustplaza303peachtreestreetatlantaga30308'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('HE Parts International',(select AddressId from [Address] where AddressHash = '1117perimetercenterwestsuiten306atlantaga30338'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Heritage Preparatory School',(select AddressId from [Address] where AddressHash = '1700piedmontaveneatlantaga30324'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Insight Sourcing Group',(select AddressId from [Address] where AddressHash = '5555triangleparkwaysuite310norcrossga30092'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Intellinet Corporation',(select AddressId from [Address] where AddressHash = 'twoconcourseparkwaysuite100atlantaga30328'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Interface, Inc.',(select AddressId from [Address] where AddressHash = '2859pacesferryroadsuite2000atlantaga30339'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Ironwood Insurance Services',(select AddressId from [Address] where AddressHash = '55ivanallenblvdsuite810atlantaga30308'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Jackson Healthcare Solutions',(select AddressId from [Address] where AddressHash = '2655northwindsparkwayalpharettaga30009'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Jackson Therapy Partners',(select AddressId from [Address] where AddressHash = '11301corporateblvdsuite101orlandofl32817'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Kennesaw State University',(select AddressId from [Address] where AddressHash = '1000chastainroadmailbox3504kennesawga30144'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('King & Spalding',(select AddressId from [Address] where AddressHash = '1180peachtreestreetatlantaga30309'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('London Broadcasting Company, Inc.',(select AddressId from [Address] where AddressHash = '5052addisoncircleaddisontx75001'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Lord, Aeck & Sargent',(select AddressId from [Address] where AddressHash = '1201peachtreeroadsuite300atlantaga30361'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Marietta Eye Clinic',(select AddressId from [Address] where AddressHash = '895cantonrdbuilding100mariettaga30060'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('McLain and Merritt, PC',(select AddressId from [Address] where AddressHash = '3445peachtreeroadnesuite500atlantaga30326'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('MI Technologies',(select AddressId from [Address] where AddressHash = '1125satelliteblvdsuite100suwaneega30024'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('NAI Brannen Goddard',(select AddressId from [Address] where AddressHash = '5555glenridgeconnectorsuite1100atlantaga30342'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('National Legal and Policy Center',(select AddressId from [Address] where AddressHash = '107parkwashingtonctfallschurchva22046'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Nease Lagana Eden & Culley',(select AddressId from [Address] where AddressHash = '2100riveredgeparkwaysuite200atlantaga30328'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Nexidia, Inc.',(select AddressId from [Address] where AddressHash = '3565piedmontrdbuilding2suite400atlantaga30305'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('NutraSweet',(select AddressId from [Address] where AddressHash = '1762loverslaneaugustaga30901'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Peak Organic Brewing',(select AddressId from [Address] where AddressHash = '6303avalondrbedfordma1730'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('People''s Financial',(select AddressId from [Address] where AddressHash = '789churchstreetmariettaga30060'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Perceptics',(select AddressId from [Address] where AddressHash = '9737cogdillrdsuite200nknoxvilletn37932'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Prepaid Solutions',(select AddressId from [Address] where AddressHash = '8001southcassavenuedarienil60561'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Progressive Logistics',(select AddressId from [Address] where AddressHash = '4executiveparkeastsuite400atlantaga30329'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Prudential Georgia Realty (PARGAR)',(select AddressId from [Address] where AddressHash = '863holcombbridgerdroswellga30076'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Regent Partners, Inc.',(select AddressId from [Address] where AddressHash = '3344peachtreerdnesuite1800atlantaga30326'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Response Media Products',(select AddressId from [Address] where AddressHash = '3155medlockbridgerdnorcrossga30071'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Restacon, LLC (Lime Restaurant)',(select AddressId from [Address] where AddressHash = '5501fultonindustrialblvdatlantaga30336'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Royal Oak',(select AddressId from [Address] where AddressHash = '1royaloakavenueroswellga30076'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Schoen Insulation',(select AddressId from [Address] where AddressHash = '850univeterroadcantonga30115'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('SEI/Aaron''s, Inc.',(select AddressId from [Address] where AddressHash = '3108piedmontroadsuite160atlantaga30305'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Sibley Heart Center Cardiology',(select AddressId from [Address] where AddressHash = 'themcgillbuilding2835brandywineroadsuite300atlanta'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('SMS Holdings',(select AddressId from [Address] where AddressHash = '7135charlottepikesuite100nashvilletn37209'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Southern Felt',(select AddressId from [Address] where AddressHash = '1695edgefieldrdnorthaugustasc29860'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Southtowne Motors',(select AddressId from [Address] where AddressHash = '800bullsborodrivenewnanga30265'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('St. Martin''s Episcopal School',(select AddressId from [Address] where AddressHash = '3110aashforddunwoodyroadatlantaga30319'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Sunbelt Structures',(select AddressId from [Address] where AddressHash = '4635northroyalatlantadrivetuckerga30084'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('SunTrust Banks, Inc.',(select AddressId from [Address] where AddressHash = '303peachtreestreetneatlantaga30308'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Taylor Mathis',(select AddressId from [Address] where AddressHash = '3500lenoxrdsuite500atlantaga30326'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('TC4',(select AddressId from [Address] where AddressHash = '211wilsonblvdsuite210arlingtonva22201'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Team One',(select AddressId from [Address] where AddressHash = '9635ventanawayalpharettaga30022'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('The Camberley Collection',(select AddressId from [Address] where AddressHash = '4405northsideparkwayatlantaga30327'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('The Ginn Group',(select AddressId from [Address] where AddressHash = '200westparkdrivesuite100peachtreecityga30269'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('The Howard School',(select AddressId from [Address] where AddressHash = '1192fosterstreetnwatlantaga303184329'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('The Paradies Shops',(select AddressId from [Address] where AddressHash = '5950fultonindustrialblvdatlantaga30336'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('The Scruggs Company',(select AddressId from [Address] where AddressHash = 'pobox2065valdostaga31604'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Van Winkle & Associates',(select AddressId from [Address] where AddressHash = '1180westpeachtreestreetnwsuite400atlantaga30309'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Wells Real Estate Funds',(select AddressId from [Address] where AddressHash = '6200thecornersparkwaynorcrossga30092'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Wesleyan School',(select AddressId from [Address] where AddressHash = '5405spaldingdrivenorcrossga30092'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Wise Business Forms',(select AddressId from [Address] where AddressHash = '555mcfarland400drivealpharettaga30004'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Wood Partners',(select AddressId from [Address] where AddressHash = '3211shannonroadsuite410durhamnc27707'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Zaid',(select AddressId from [Address] where AddressHash = '5501fultonindustrialblvdatlantaga30336'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Atlanta Housing Authority',(select AddressId from [Address] where AddressHash = '230johnwesleydobbsavenueatlantaga30303'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Archer Daniels Midland',(select AddressId from [Address] where AddressHash = '4666fariesparkwaydecaturil62526'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Habitat for Humanity',(select AddressId from [Address] where AddressHash = '270peachtreestreetsuite1300atlantaga30303'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Reagan Consulting',(select AddressId from [Address] where AddressHash = 'onepiedmontcentersuite500atlantaga30305'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Renaissance Management',(select AddressId from [Address] where AddressHash = '2300westparkplacestonemountainga30087'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('CallMe! Staffing',(select AddressId from [Address] where AddressHash = '1glenlakeparkwaysuite1225atlantaga30082'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Themis Trust',(select AddressId from [Address] where AddressHash = '2111wilsonblvdsuite210arlingtonva22201'),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);
 insert into dbo.Client([ClientName],[AddressId],[ClientTypeId],[IsActive]) values ('Brent Scarbrough',(select AddressId from dbo.[Address] where AddressHash = ('155robinsondrivefayettevillega30214')),(select distinct ClientTypeId from dbo.ClientTypes where ClientTypeName ='Corporate Brokerage'),1);



 
---Person


insert into Person ([LastName],[FirstName],[AddressId]) values ('Almeter','John',(select AddressId from [Address] where AddressHash = '1000marblemillcirclemariettaga30060'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Altman','Mary',(select AddressId from [Address] where AddressHash = '3500lenoxrdsuite500atlantaga30326' ));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Anderson','Deb',(select AddressId from [Address] where AddressHash = '3211shannonroadsuite410durhamnc27707' ));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Arnold','Byron',(select AddressId from [Address] where AddressHash = '3565piedmontrdbuilding2suite400atlantaga30305' ));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Ayittey','Cynthia',(select AddressId from [Address] where AddressHash = '191peachtreesuite2400atlantaga303031740'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Baird','Shannon',(select AddressId from [Address] where AddressHash = '5555glenridgeconnectorsuite1100atlantaga30342' ));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Berger','Dick',(select AddressId from [Address] where AddressHash = '3445peachtreeroadsuite500atlantaga30326') );
insert into Person ([LastName],[FirstName],[AddressId]) values ('Bethel','Michelle',(select AddressId from [Address] where AddressHash = '9737cogdillrdsuite200nknoxvilletn37932') );
insert into Person ([LastName],[FirstName],[AddressId]) values ('Bobar','Kathy',(select AddressId from [Address] where AddressHash = '3205northwoodsparkwaynorcrossga30071') );
insert into Person ([LastName],[FirstName],[AddressId]) values ('Bossert','Rod',(select AddressId from [Address] where AddressHash = '1000chastainroadmailbox3504kennesawga30144') );
insert into Person ([LastName],[FirstName],[AddressId]) values ('Brady','Jeannie',(select AddressId from [Address] where AddressHash = '430technologyparkwaynorcrossga30092') );
insert into Person ([LastName],[FirstName],[AddressId]) values ('Brooks','Tonya',(select AddressId from [Address] where AddressHash = 'twoconcourseparkwaysuite300atlantaga30328') );
insert into Person ([LastName],[FirstName],[AddressId]) values ('Buckley','Laurie',(select AddressId from [Address] where AddressHash = '280technologyparkwaynorcrossga30092') );
insert into Person ([LastName],[FirstName],[AddressId]) values ('Bye','Angie',(select AddressId from [Address] where AddressHash = '1100lakehearndrsuite450atlantaga30342') );
insert into Person ([LastName],[FirstName],[AddressId]) values ('Caverly','Kristina',(select AddressId from [Address] where AddressHash = '6303avalondrbedfordma01730') );
insert into Person ([LastName],[FirstName],[AddressId]) values ('Christensen','Daryl', (select AddressId from [Address] where AddressHash = '3651marshillrdsuite400watkinsvillega30677'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Colosetti','Connie', (select AddressId from [Address] where AddressHash = '5501fultonindustrialblvdatlantaga30336'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Cook','Mark', (select AddressId from [Address] where AddressHash = '1glenlakeparkwaysuite1225atlantaga30082'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Cooper','Darlene', (select AddressId from [Address] where AddressHash = '2300westparkplacestonemountainga30087'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Copenhaver','Jodi', (select AddressId from [Address] where AddressHash = '5950fultonindustrialblvdatlantaga30336'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Cox','Hiram', (select AddressId from [Address] where AddressHash = '7135charlottepikesuite100nashvilletn37209'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Crowe','Kristen', (select AddressId from [Address] where AddressHash = '2849pacesferryrdsuite350atlantaga30339'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Culler','Dale', (select AddressId from [Address] where AddressHash = '2100riveredgeparkwaysuite200atlantaga30328'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Cunningham','Nancy', (select AddressId from [Address] where AddressHash = '5555triangleparkwaysuite310norcrossga30092'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Dalach','Dan', (select AddressId from [Address] where AddressHash = '1000ternesdrivemonroemi48162'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Davis','Canley', (select AddressId from [Address] where AddressHash = '5457roswellrdsuite208atlantaga30342'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Davis','Julie', (select AddressId from [Address] where AddressHash = '2655northwindsparkwayalpharettaga30004'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('de la Riva','Heather', (select AddressId from [Address] where AddressHash = '2111wilsonblvdsuite350arlingtonva22201'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Dillon','Mary', (select AddressId from [Address] where AddressHash = '229peachtreestreetsuite800atlantaga30303'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('DiMarzio','Mary Ann', (select AddressId from [Address] where AddressHash = '9635ventanawayalpharettaga30022'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Doonan','Jay', (select AddressId from [Address] where AddressHash = '150mountvernonstbostonma02125'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Dossett','Tina', (select AddressId from [Address] where AddressHash = '3344peachtreerdnesuite1800atlantaga30326'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Duerr','Douglas', (select AddressId from [Address] where AddressHash = '229peachtreestreetsuite800atlantaga30303'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Dyson','Kim', (select AddressId from [Address] where AddressHash = '2600schooldriveatlantaga30360'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Early','Jae', (select AddressId from [Address] where AddressHash = '270peachtreestreetsuite1300atlantaga30303'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Easton','Kimberly', (select AddressId from [Address] where AddressHash = '4405northsideparkwayatlantaga30327'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Eiland','Brent', (select AddressId from [Address] where AddressHash = '5555triangleparkwaysuite310norcrossga30092'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Elliott','Bob', (select AddressId from [Address] where AddressHash = '4000suntrustplaza303peachtreestreetatlantaga30308'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Elliott','Karen', (select AddressId from [Address] where AddressHash = '1000chastainroadmailbox3504kennesawga30144'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Fay','Mike', (select AddressId from [Address] where AddressHash = '7135charlottepikesuite100nashvilletn37209'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Fedors','Lendy', (select AddressId from [Address] where AddressHash = '125southshorecourtroswellga30076'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Felkel','Beth', (select AddressId from [Address] where AddressHash = 'themcgillbuilding2835brandywineroadsuite300atlanta'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Flaherty','Peter', (select AddressId from [Address] where AddressHash = '107parkwashingtonctfallschurchva22046'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Flippin','Nancy', (select AddressId from [Address] where AddressHash = '732josephelowryblvdnwatlantaga30318'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Floyd','Teresa', (select AddressId from [Address] where AddressHash = '1100lakehearndrsuite450atlantaga30342'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Fowler','Robert', (select AddressId from [Address] where AddressHash = '789churchstreetmariettaga30060'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Fransoso','Steve', (select AddressId from [Address] where AddressHash = '1695edgefieldrdnorthaugustasc29860'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Garrett','Claudette', (select AddressId from [Address] where AddressHash = '732josephelowryblvdnwatlantaga30318'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Gash','JoVahn', (select AddressId from [Address] where AddressHash = '1201peachtreeroadsuite300atlantaga30361'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Gilligan','Tom', (select AddressId from [Address] where AddressHash = '5555glenridgeconnectorsuite1100atlantaga30342'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Goodman','Lisa', (select AddressId from [Address] where AddressHash = '191peachtreesuite2400atlantaga303031740'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Graves','Chad', (select AddressId from [Address] where AddressHash = '4808claybrookedrivesmyrnaga30087'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Gray','Heather', (select AddressId from [Address] where AddressHash = '750mtzionroadjonesboroga30236'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Gray','Jerry', (select AddressId from [Address] where AddressHash = '9635ventanawayalpharettaga30022'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Greenberg','Mark', (select AddressId from [Address] where AddressHash = '895cantonroadmariettaga30060'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Griffeth','Claudia', (select AddressId from [Address] where AddressHash = '1192fosterstreetnwatlantaga303184329'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hamilton','Pam', (select AddressId from [Address] where AddressHash = 'pobox1530adelga31620'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hamner','James', (select AddressId from [Address] where AddressHash = '3110aashforddunwoodyroadatlantaga30319'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Harper','Linsey', (select AddressId from [Address] where AddressHash = '555mcfarland400drivealpharettaga30004'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Harris','Christy', (select AddressId from [Address] where AddressHash = '130technologyparkwaynorcrossga30092'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hartwig','Ute', (select AddressId from [Address] where AddressHash = '1180peachtreestreetatlantaga30309'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hawkins','Donna', (select AddressId from [Address] where AddressHash = '3621viningsslopesuite400atlantaga30339'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hawthorne','Kathy', (select AddressId from [Address] where AddressHash = 'pobox70681620bassroadmaconga312097068'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Heard','Patti', (select AddressId from [Address] where AddressHash = '1royaloakavenueroswellga30076'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hearn','Marty', (select AddressId from [Address] where AddressHash = '151walkerroadstatesvillenc28625'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hembrick','Monica', (select AddressId from [Address] where AddressHash = 'twoconcourseparkwaysuite300atlantaga30328'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hicks','Teresa', (select AddressId from [Address] where AddressHash = '4666fariesparkwaydecaturil62526'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hiedi','Kozlowski', (select AddressId from [Address] where AddressHash = '1000ternesdrivemonroemi48162'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hiffa','Mike', (select AddressId from [Address] where AddressHash = '2655northwindsparkwayalpharettaga30004'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hildebrand','Keith', (select AddressId from [Address] where AddressHash = '101mariettastreetsuite1900atlantaga30303'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Hobson','Brad', (select AddressId from [Address] where AddressHash = '101mariettastreetsuite1900atlantaga30303'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Holcombe','Pebbles', (select AddressId from [Address] where AddressHash = '2859pacesferryroadsuite2000atlantaga30339'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Holmquest','Christopher', (select AddressId from [Address] where AddressHash = '150mountvernonstbostonma02125'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Houk','Jackson', (select AddressId from [Address] where AddressHash = '359eastpacesferryroadsuite300atlantaga30305'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Irwin','Myla', (select AddressId from [Address] where AddressHash = 'twoconcourseparkwaysuite100atlantaga30328'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Johnson','Susanna ', (select AddressId from [Address] where AddressHash = '6200thecornersparkwaynorcrossga30092'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Jones','Anissa', (select AddressId from [Address] where AddressHash = '895cantonroadmariettaga30060'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Justice','Samantha', (select AddressId from [Address] where AddressHash = 'themcgillbuilding2835brandywineroadsuite300atlanta'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Kelleher','Marnie', (select AddressId from [Address] where AddressHash = '2600schooldriveatlantaga30360'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Kilgore','Janis', (select AddressId from [Address] where AddressHash = '4000suntrustplaza303peachtreestreetatlantaga30308'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Kirkwood','Diane', (select AddressId from [Address] where AddressHash = '231whancockstreethallhousemilledgevillega310613375'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Kline','Doug', (select AddressId from [Address] where AddressHash = '2655northwindsparkwayalpharettaga30004'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('L''Heureux','Scott', (select AddressId from [Address] where AddressHash = '11301corporateblvdsuite101orlandofl32817'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Lange','Donna', (select AddressId from [Address] where AddressHash = '303peachtreestreetneatlantaga30308'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Law','Tina', (select AddressId from [Address] where AddressHash = '800bullsborodrivenewnanga30265'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Lee','Natalie', (select AddressId from [Address] where AddressHash = '4666fariesparkwaydecaturil62526'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Lee','Presley', (select AddressId from [Address] where AddressHash = 'oneraviniadrivesuite200atlantaga30346'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Lloyd-Jones','Ian', (select AddressId from [Address] where AddressHash = '4405northsideparkwayatlantaga30327'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Lukens','Shirley', (select AddressId from [Address] where AddressHash = 'onepiedmontcentersuite500atlantaga30305'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Maloney','Kathryn', (select AddressId from [Address] where AddressHash = '150mountvernonstbostonma02125'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Manns','Melissa', (select AddressId from [Address] where AddressHash = '230johnwesleydobbsavenueatlantaga30303'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Marek','Don', (select AddressId from [Address] where AddressHash = '5950fultonindustrialblvdatlantaga30336'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Martinez','Irene', (select AddressId from [Address] where AddressHash = '11301corporateblvdsuite101orlandofl32817'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Martinez-Patin','Cynthia', (select AddressId from [Address] where AddressHash = '11301corporateblvdsuite101orlandofl32817'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Massey','Joe', (select AddressId from [Address] where AddressHash = '4635northroyalatlantadrivetuckerga30084'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('May','Andy', (select AddressId from [Address] where AddressHash = '6200thecornersparkwaynorcrossga30092'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('McClure','Linda',(select AddressId from [Address] where AddressHash = '359eastpacesferryroadsuite300atlantaga30305' ));
insert into Person ([LastName],[FirstName],[AddressId]) values ('McIntosh','Angie', (select AddressId from [Address] where AddressHash = '3108piedmontroadsuite160atlantaga30305'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('McMackin','Michael', (select AddressId from [Address] where AddressHash = '3155medlockbridgerdnorcrossga30071'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Melroy','Paul', (select AddressId from [Address] where AddressHash = '1575northsidedrivebuilding300suite350atlantaga3031'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Midha','Gina', (select AddressId from [Address] where AddressHash = '1117perimetercenterwestsuiten306atlantaga30328'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Mills','Katie', (select AddressId from [Address] where AddressHash = '3651marshillrdsuite400watkinsvillega30677'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Mink','Randy', (select AddressId from [Address] where AddressHash = '2655northwindsparkwayalpharettaga30004'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Monique','Shaw', (select AddressId from [Address] where AddressHash = '732josephelowryblvdnwatlantaga30318'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Mooney','Francie', (select AddressId from [Address] where AddressHash = '55ivanallenblvdsuite810atlantaga30308'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Moore','Terri', (select AddressId from [Address] where AddressHash = '3565piedmontrdbuilding2suite400atlantaga30305'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Morriss','Penny', (select AddressId from [Address] where AddressHash = '3715northsideparkwaynwbuilding200suite440atlantaga'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Motley','Linda', (select AddressId from [Address] where AddressHash = '8001southcassavenuedarienil60561'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Murphy','Kathy', (select AddressId from [Address] where AddressHash = '863holcombbridgerdroswellga30076'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Mutter','Cathy', (select AddressId from [Address] where AddressHash = '200westparkdrivesuite100peachtreecityga30269'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Mutvic','George', (select AddressId from [Address] where AddressHash = 'pobox70681620bassroadmaconga312097068'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Nama','Mary Ann', (select AddressId from [Address] where AddressHash = '3110aashforddunwoodyroadatlantaga30319'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Napier','Janis', (select AddressId from [Address] where AddressHash = '1695edgefieldrdnorthaugustasc29860'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Oliver','Diane', (select AddressId from [Address] where AddressHash = '3110aashforddunwoodyroadatlantaga30319'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Owens','Davies', (select AddressId from [Address] where AddressHash = '1700piedmontaveneatlantaga30324'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Pare','Carol', (select AddressId from [Address] where AddressHash = '1349wpeachtreestnwsuite1700atlantaga30309'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Pastor','Holly', (select AddressId from [Address] where AddressHash = '1125satelliteblvdsuite100suwaneega30024'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Pendley','Amy', (select AddressId from [Address] where AddressHash = 'pobox70681620bassroadmaconga312097068'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Pepon','Pat', (select AddressId from [Address] where AddressHash = '863holcombbridgerdroswellga30076'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Prescher','Janet', (select AddressId from [Address] where AddressHash = '2100riveredgeparkwaysuite200atlantaga30328'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Ray','Allan', (select AddressId from [Address] where AddressHash = '4executiveparkeastsuite400atlantaga30329'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Reed','Jeff', (select AddressId from [Address] where AddressHash = '151walkerroadstatesvillenc28625'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Riley','Jenny', (select AddressId from [Address] where AddressHash = '4executiveparkeastsuite400atlantaga30329'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Russell','Les', (select AddressId from [Address] where AddressHash = '5950fultonindustrialblvdatlantaga30336'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Salam','Gayle', (select AddressId from [Address] where AddressHash = '1180peachtreestreetatlantaga30309'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Schoen','Stephen', (select AddressId from [Address] where AddressHash = '850univeterroadcantonga30115'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Seaborn','Veronica', (select AddressId from [Address] where AddressHash = '1301newsavannahroadaugustaga30901'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Sessoms','Rhonda', (select AddressId from [Address] where AddressHash = '3211shannonroadsuite410durhamnc27707'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Sharp','Beverly', (select AddressId from [Address] where AddressHash = '5052addisoncircleaddisontx75001'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Shutte','Linda', (select AddressId from [Address] where AddressHash = '5405spaldingdrivenorcrossga30092'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Sibley','Jack', (select AddressId from [Address] where AddressHash = '4000suntrustplaza303peachtreestreetatlantaga30308'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Sims','Scott', (select AddressId from [Address] where AddressHash = '2416musicvalleydrivesuite102nashvilletn37214'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Smith','Charlie', (select AddressId from [Address] where AddressHash = '1125satelliteblvdsuite100suwaneega30024'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Speer','Lorena', (select AddressId from [Address] where AddressHash = '5501fultonindustrialblvdatlantaga30336'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Stejskal','Bill', (select AddressId from [Address] where AddressHash = '7135charlottepikesuite100nashvilletn37209'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Stevenson','Mike', (select AddressId from [Address] where AddressHash = '1201peachtreeroadsuite300atlantaga30361'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Stewart','Steve', (select AddressId from [Address] where AddressHash = 'oneraviniadrivesuite200atlantaga30346'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Stignani','Alicia', (select AddressId from [Address] where AddressHash = '1000chastainroadmailbox3504kennesawga30144'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Stukes','Javacia', (select AddressId from [Address] where AddressHash = '1762loverslaneaugustaga30901'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Tanner','Stephen', (select AddressId from [Address] where AddressHash = '5700sw34thstreetgainesvillefl32608'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Tarver','Kimberly', (select AddressId from [Address] where AddressHash = '231whancockstreethallhousemilledgevillega310613375'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Tate','Stacey', (select AddressId from [Address] where AddressHash = '800bullsborodrivenewnanga30265'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Teets','Charlie', (select AddressId from [Address] where AddressHash = '555mcfarland400drivealpharettaga30004'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Tinoco','Michelle', (select AddressId from [Address] where AddressHash = '155robinsondrivefayettevillega30214'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Trammel','Jennifer', (select AddressId from [Address] where AddressHash = '1201peachtreeroadsuite300atlantaga30361'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Traner','Donna', (select AddressId from [Address] where AddressHash = '5555glenridgeconnectorsuite1100atlantaga30342'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Turner','Susan', (select AddressId from [Address] where AddressHash = '5457roswellrdsuite208atlantaga30342'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Underwood','Will', (select AddressId from [Address] where AddressHash = '55ivanallenblvdsuite810atlantaga30308'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Van Winkle','Alex', (select AddressId from [Address] where AddressHash = '1180westpeachtreestreetnwsuite400atlantaga30309'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Velez','Cherie', (select AddressId from [Address] where AddressHash = '2111wilsonblvdsuite210arlingtonva22201'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Walls','Elizabeth', (select AddressId from [Address] where AddressHash = '5950fultonindustrialblvdatlantaga30336'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Ward','Carol', (select AddressId from [Address] where AddressHash = '231whancockstreethallhousemilledgevillega310613375'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Weiler','Alan', (select AddressId from [Address] where AddressHash = '1192fosterstreetnwatlantaga303184329'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Wheeler','Wanda', (select AddressId from [Address] where AddressHash = '1762loverslaneaugustaga30901'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Wisenbaker','Larry', (select AddressId from [Address] where AddressHash = 'pobox2065valdostaga31604'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Wolff','Lynn', (select AddressId from [Address] where AddressHash = '1819peachtreeroadsuite425atlantaga30309'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Yeager','Jeff', (select AddressId from [Address] where AddressHash = '3651marshillrdsuite400watkinsvillega30677'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Yerden','David', (select AddressId from [Address] where AddressHash = '3344peachtreerdnesuite1800atlantaga30326'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Prettyman','Bill', (select AddressId from [Address] where AddressHash = '555mcfarland400drivealpharettaga30004'));
insert into Person ([LastName],[FirstName],[AddressId]) values ('Padgett','Becky', (select AddressId from [Address] where AddressHash = '6200thecornersparkwaynorcrossga30092'));

--Dominium Sales team
insert into Person ([FirstName],[LastName],[AddressId]) values ('Linda',' Schulte',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Julie',' Stannard',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Janet',' Smith',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Tonia',' Scofield',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Ted',' Schweers',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Susan',' Prout',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Lori',' Nipp',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Julie',' Mizell',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Susan',' Harris',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Melissa',' Frieswick',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Lauren',' Darr',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Caryn',' Cook',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Mark',' Watson',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Stephen',' Boyd',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Cory',' Hurley',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));
insert into Person ([FirstName],[LastName],[AddressId]) values ('Dominium',' Benefits',(select AddressId from [Address] where AddressHash = 'fiveconcourseparkwaysuite2325atlantaga30328'));


--Default Sales Roles per team member

insert into dbo.SalesTeam([PersonId],[SalesRoleId])values ((select PersonId from Person where FirstName like '%Julie%' and LastName like '%Stannard%'),
			(select SalesRoleId from SalesRole where RoleName = 'Service Account Exec'));	
insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Lauren%' and LastName like '%Darr%'),
			(select SalesRoleId from SalesRole where RoleName = 'Service Account Exec'));
insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Linda%' and LastName like '%Schulte%'),
			(select SalesRoleId from SalesRole where RoleName = 'Consultant'));	

insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Janet%' and LastName like '%Smith%'),
			(select SalesRoleId from SalesRole where RoleName = 'Service Account Exec'));	

insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Tonia%' and LastName like '%Scofield%'),
			(select SalesRoleId from SalesRole where RoleName = 'Service Account Exec'));	

insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Ted%' and LastName like '%Schweers%'),
			(select SalesRoleId from SalesRole where RoleName = 'Producer'));	

insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Susan%' and LastName like '%Prout%'),
			(select SalesRoleId from SalesRole where RoleName = 'Service Account Exec'));	


insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Lori%' and LastName like '%Nipp%'),
			(select SalesRoleId from SalesRole where RoleName = 'Service Account Exec'));	

insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Julie%' and LastName like '%Mizell%'),
			(select SalesRoleId from SalesRole where RoleName = 'Service Account Exec'));	

insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Susan%' and LastName like '%Harris%'),
			(select SalesRoleId from SalesRole where RoleName = 'Service Account Exec'));	
			
			insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Melissa%' and LastName like '%Frieswick%'),
			(select SalesRoleId from SalesRole where RoleName = 'Service Account Exec'));	
			
						insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Caryn%' and LastName like '%Cook%'),
			(select SalesRoleId from SalesRole where RoleName = 'Producer'));	

						insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Cory%' and LastName like '%Hurley%'),
			(select SalesRoleId from SalesRole where RoleName = 'Producer'));
			
						insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Mark%' and LastName like '%Watson%'),
			(select SalesRoleId from SalesRole where RoleName = 'Producer'));		
			
						
						insert into dbo.SalesTeam([PersonId],[SalesRoleId])values 
((select PersonId from Person where FirstName like '%Stephen%' and LastName like '%Boyd%'),
			(select SalesRoleId from SalesRole where RoleName = 'Producer'));
			
							


---Carrriers
insert into Carrier (CarrierName) values ('Aetna');
insert into Carrier (CarrierName) values ('Ashford');
insert into Carrier (CarrierName) values ('Assurant Employee Benefits');
insert into Carrier (CarrierName) values ('BCBS GA');
insert into Carrier (CarrierName) values ('BCBS IL');
insert into Carrier (CarrierName) values ('BCBS MASS');
insert into Carrier (CarrierName) values ('BCBS Michigan');
insert into Carrier (CarrierName) values ('BCBS MT');
insert into Carrier (CarrierName) values ('BCBS TN');
insert into Carrier (CarrierName) values ('Benefit Mall');
insert into Carrier (CarrierName) values ('Boulder');
insert into Carrier (CarrierName) values ('Cigna');
insert into Carrier (CarrierName) values ('Colonial Insurance');
insert into Carrier (CarrierName) values ('CompBenefits');
insert into Carrier (CarrierName) values ('Coventry');
insert into Carrier (CarrierName) values ('Delta Dental');
insert into Carrier (CarrierName) values ('EyeMed');
insert into Carrier (CarrierName) values ('Execucare');
insert into Carrier (CarrierName) values ('Fiserv Health');
insert into Carrier (CarrierName) values ('Genworth Life and Health Insurance Compan');
insert into Carrier (CarrierName) values ('Guardian');
insert into Carrier (CarrierName) values ('GWLA');
insert into Carrier (CarrierName) values ('Hanleigh Management, Inc.');
insert into Carrier (CarrierName) values ('Hartford Life');
insert into Carrier (CarrierName) values ('HCC LIFE');
insert into Carrier (CarrierName) values ('Humana');
insert into Carrier (CarrierName) values ('ING');
insert into Carrier (CarrierName) values ('John Alden LIfe Insurance Company');
insert into Carrier (CarrierName) values ('Kaiser Permanente');
insert into Carrier (CarrierName) values ('Lincoln Financial Group');
insert into Carrier (CarrierName) values ('MetLife');
insert into Carrier (CarrierName) values ('Mutual of Omaha');
insert into Carrier (CarrierName) values ('National Guardian');
insert into Carrier (CarrierName) values ('Optima(UMR)');
insert into Carrier (CarrierName) values ('Principal Financial Group');
insert into Carrier (CarrierName) values ('Prudential Financial');
insert into Carrier (CarrierName) values ('Reliance Standard');
insert into Carrier (CarrierName) values ('Smith Administrators/EMS LP');
insert into Carrier (CarrierName) values ('Smytra');
insert into Carrier (CarrierName) values ('SRC- An Aetna Company');
insert into Carrier (CarrierName) values ('Standard Insurance Company');
insert into Carrier (CarrierName) values ('Sun Life');
insert into Carrier (CarrierName) values ('Superior Vision');
insert into Carrier (CarrierName) values ('The Milner Group');
insert into Carrier (CarrierName) values ('UMR');
insert into Carrier (CarrierName) values ('United Concordia');
insert into Carrier (CarrierName) values ('United Healthcare');
insert into Carrier (CarrierName) values ('UNUM - C');
insert into Carrier (CarrierName) values ('Vision Service Plan');
insert into Carrier (CarrierName) values ('Zurich American Insurance Company');
insert into Carrier (CarrierName) values ('Miscellaneous');

---Contacts
